1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
12 "http://www.w3.org/TR/html4/loose.dtd">
13 <html>
14 <head>
15 <title>Welcome to Stock Management System !</title>
16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
17 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <script src="js/jquery.min.js" type="text/javascript"></script>
20 <script type="text/javascript" src="jquery.date_input.js"></script>
21 <link rel="stylesheet" href="date_input.css" type="text/css">
22 <script type="text/javascript">$(function() {
23 $("#expiry").date_input();
24
25 });</script>
26 <script type='text/javascript' src='lib/jquery.bgiframe.min.js'></script>
27 <script type='text/javascript' src='lib/jquery.ajaxQueue.js'></script>
28 <script type='text/javascript' src='lib/thickbox-compressed.js'></script>
29 <script type='text/javascript' src='jquery.autocomplete.js'></script>
30 <script type='text/javascript' src='localdata.js'></script>
31
32 <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
33 <link rel="stylesheet" type="text/css" href="lib/thickbox.css" />
34
35 <script type="text/javascript">
36 $().ready(function() {
37
38 function log(event, data, formatted) {
39 $("<li>").html( !data ? "No match!" : "Selected: " + formatted).appendTo("#result");
40 }
41
42 function formatItem(row) {
43 return row[0] + " (<strong>id: " + row[1] + "</strong>)";
44 }
45 function formatResult(row) {
46 return row[0].replace(/(<.+?>)/gi, '');
47 }
48
49
50
51 $("#singleBirdRemote").autocomplete("category.php", {
52 width: 160,
53 autoFill: true,
54 selectFirst: false
55 });
56 $("#supplier").autocomplete("supplier1.php", {
57 width: 160,
58 autoFill: true,
59 selectFirst: false
60 });
61
62
63 $("#clear").click(function() {
64 $(":input").unautocomplete();
65 });
66 });
67
68
69 </script>
70
71 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
72 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
73 <script src="js/jquery.hotkeys-0.7.9.js"></script>
74 <!-- AJAX SUCCESS TEST FONCTION
75 <script>function callSuccessFunction(){alert("success executed")}
76 function callFailFunction(){alert("fail executed")}
77 </script>
78 -->
79
80 <script>
81
82
83
84
85
86 $(document).ready(function() {
87 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
88 $("#name").focus();
89 $("#form1").validationEngine(),
90
91 jQuery(document).bind('keydown', 'Ctrl+s',function() {
92 $('#form1').submit();
93 return false;
94 });
95
96 jQuery(document).bind('keydown', 'Ctrl+r',function() {
97 $('#form1').reset();
98 return false;
99 });
100 jQuery(document).bind('keydown', 'Ctrl+a',function() {
101 window.location = "add_stock_details.php";
102 return false;
103 });
104 jQuery(document).bind('keydown', 'Ctrl+0',function() {
105 window.location = "admin.php";
106 return false;
107 });
108 jQuery(document).bind('keydown', 'Ctrl+1',function() {
109 window.location = "add_purchase.php";
110 return false;
111 });
112 jQuery(document).bind('keydown', 'Ctrl+2',function() {
113 window.location = "add_stock_sales.php";
114 return false;
115 });
116 jQuery(document).bind('keydown', 'Ctrl+3',function() {
117 window.location = "add_stock_details.php";
118 return false;
119 });
120 jQuery(document).bind('keydown', 'Ctrl+4',function() {
121 window.location = "add_category.php";
122 return false;
123 });
124 jQuery(document).bind('keydown', 'Ctrl+5',function() {
125 window.location = "add_supplier_details.php";
126 return false;
127 });
128 jQuery(document).bind('keydown', 'Ctrl+6',function() {
129 window.location = "add_customer_details.php";
130 return false;
131 });
132 jQuery(document).bind('keydown', 'Ctrl+7',function() {
133 window.location = "view_stock_entries.php";
134 return false;
135 });
136 jQuery(document).bind('keydown', 'Ctrl+8',function() {
137 window.location = "view_stock_sales.php";
138 return false;
139 });
140 jQuery(document).bind('keydown', 'Ctrl+9',function() {
141 window.location = "view_stock_details.php";
142 return false;
143 });
144 //$.validationEngine.loadValidation("#date")
145 //alert($("#formID").validationEngine({returnIsValid:true}))
146 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
147 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
148 });
149 </script>
150 <style type="text/css">
151 <!--
152 body {
153 margin-left: 0px;
154 margin-top: 0px;
155 margin-right: 0px;
156 margin-bottom: 0px;
157 background-color: #FFFFFF;
158 }
159
160 *{
161 padding: 0px;
162 margin: 0px;
163 }
164 #vertmenu {
165 font-family: Verdana, Arial, Helvetica, sans-serif;
166 font-size: 100%;
167 width: 160px;
168 padding: 0px;
169 margin: 0px;
170 }
171
172 #vertmenu h1 {
173 display: block;
174 background-color:#FF9900;
175 font-size: 90%;
176 padding: 3px 0 5px 3px;
177 border: 1px solid #000000;
178 color: #333333;
179 margin: 0px;
180 width:159px;
181 }
182
183 #vertmenu ul {
184 list-style: none;
185 margin: 0px;
186 padding: 0px;
187 border: none;
188 }
189 #vertmenu ul li {
190 margin: 0px;
191 padding: 0px;
192 }
193 #vertmenu ul li a {
194 font-size: 80%;
195 display: block;
196 border-bottom: 1px dashed #C39C4E;
197 padding: 5px 0px 2px 4px;
198 text-decoration: none;
199 color: #666666;
200 width:160px;
201 }
202
203 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
204 color: #000000;
205 background-color: #eeeeee;
206 }
207 .style1 {color: #000000}
208
209 -->
210 </style>
211 </head>
212
213 <body>
214 <table width="100%" border="0" cellspacing="0" cellpadding="0">
215 <tr>
216 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
217 <tr>
218 <td><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
219 <tr>
220 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
221 </tr>
222 <tr>
223 <td height="800" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
224 <tr>
225 <td width="130" align="left" valign="top">
226
227 <br>
228
229 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
230 <table width="100%" border="0" cellspacing="0" cellpadding="0">
231 <tr>
232 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
233 </tr>
234 <tr>
235 <td align="center"> </td>
236 </tr>
237 <tr>
238 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
239 </tr>
240 <tr>
241 <td align="center"> </td>
242 </tr>
243 <tr>
244 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
245 </tr>
246 <tr>
247 <td align="center"> </td>
248 </tr>
249 <tr>
250 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
251 </tr>
252 <tr>
253 <td align="center"> </td>
254 </tr>
255 <tr>
256 <td align="center"> </td>
257 </tr>
258 <tr>
259 <td align="center"> </td>
260 </tr>
261 </table>
262
263
264
265
266
267 </td> <td height="500" align="center" valign="top">
268 <table width="100%" border="0" cellspacing="0" cellpadding="0">
269 <tr>
270 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
271 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
272 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
273 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
274 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
275 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
276 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
277 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
278 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
279 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
280 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
281 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
282 </tr>
283 </table>
284 <?php
285 if(isset($_POST['name']))
286
287 {
288
289 $id=mysql_real_escape_string($_POST['id']);
290 $name=mysql_real_escape_string($_POST['name']);
291 $category=mysql_real_escape_string($_POST['category']);
292 $buyingrate=mysql_real_escape_string($_POST['buyingrate']);
293 $sellingrate=mysql_real_escape_string($_POST['sellingrate']);
294 $suplier=mysql_real_escape_string($_POST['suplier']);
295 $uom=mysql_real_escape_string($_POST['uom']);
296
297 $count = $db->countOf("stock_details", "stock_id='$id'");
298 if($count==1)
299 {
300 echo "<font color=red> Dublicat Entry. Please Verify</font>";
301 }
302 else
303 {
304
305 if($db->query("insert into stock_details(stock_id,stock_name,stock_quatity,supplier_id,company_price,selling_price,category) values('$id','$name',0,'$suplier',$buyingrate,$sellingrate,'$category')"))
306 {
307 echo "<br><font color=green size=+1 > [$name] Stock Details Added !</font>" ;
308 $db->query("insert into stock_avail(name,quantity) values('$name',0)");
309 }
310
311 else
312 echo "<br><font color=red size=+1 >Problem in Adding !</font>" ;
313
314 }
315
316
317 }
318
319 ?>
320
321 <br>
322 <br>
323
324
325 <form name="form1" method="post" id="form1" action="">
326
327 <p align="center"><strong>Add New Stock Details </strong> - Add New ( Control +A)</p>
328 <table width="300" border="0" cellspacing="0" cellpadding="0">
329 <tr>
330 <td width="150"> </td>
331 <td width="150"> </td>
332 </tr>
333 <tr>
334 <td width="150"> </td>
335 <td width="150"> </td>
336 </tr>
337 <tr>
338 <td width="150">ID</td>
339 <?php
340 $max = $db->maxOfAll("id", "stock_details");
341 $max=$max+1;
342 $autoid="SD".$max."";
343 ?>
344 <td width="150"><input name="id" type="text" id="id" readonly="" value="<?php echo $autoid; ?>"></td>
345 </tr>
346 <tr>
347 <td width="150"> </td>
348 <td width="150"> </td>
349 </tr>
350 <tr>
351 <td width="150">Name</td>
352 <td width="150"><input name="name" type="text" id="name" class="validate[required,length[0,100]] text-input"></td>
353 </tr>
354 <tr>
355 <td width="150"> </td>
356 <td width="150"> </td>
357 </tr>
358 <tr>
359 <td width="150">Category</td>
360 <td width="150"><input name="category" type="text" id="singleBirdRemote"></td>
361 </tr>
362 <tr>
363 <td> </td>
364 <td> </td>
365 </tr>
366 <tr>
367 <td>Buying Rate</td>
368 <td><input name="buyingrate" type="text" id="buyingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
369 </tr>
370 <tr>
371 <td> </td>
372 <td> </td>
373 </tr>
374 <tr>
375 <td>Selling Rate </td>
376 <td><input name="sellingrate" type="text" id="sellingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
377 </tr>
378 <tr>
379 <td> </td>
380 <td> </td>
381 </tr>
382 <tr>
383 <td>Suplier Name</td>
384 <td><input name="suplier" type="text" id="supplier" class="validate[optional,length[0,100]] text-input"></td>
385 </tr>
386 <tr>
387 <td> </td>
388 <td> </td>
389 </tr>
390
391 <td> </td>
392 <td> </td>
393 </tr>
394 <tr>
395 <td> </td>
396 <td> </td>
397 </tr>
398 <tr>
399 <td align="right"><input type="reset" name="Reset" value="Reset"> </td>
400 <td>
401 <input type="submit" name="Submit" value="Save"></td>
402 </tr>
403 <tr>
404 <td align="center"> (Control + R) </td>
405 <td align="left"> ( Control + S ) </td>
406 </tr>
407 </table>
408 </form></td>
409 </tr>
410 </table>
411
412 </td>
413 </tr>
414 <tr>
415 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
416 </tr>
417 </table></td>
418 </tr>
419 </table></td>
420 </tr>
421 </table>
422
423 </body>
424 </html>
425 <?php
426 }
427 ?>